<?php exit(); ?>
-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_categories`
-- 

DROP TABLE IF EXISTS `ibf_registry_categories`;
CREATE TABLE `ibf_registry_categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `image_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  KEY `title` (`title`(100)),
  KEY `id` (`id`,`title`(100))
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_config`
-- 

DROP TABLE IF EXISTS `ibf_registry_config`;
CREATE TABLE `ibf_registry_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) default NULL,
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_field_defs`
-- 

DROP TABLE IF EXISTS `ibf_registry_field_defs`;
CREATE TABLE `ibf_registry_field_defs` (
  `field_id` int(10) unsigned NOT NULL auto_increment,
  `field_name` varchar(255) NOT NULL default '',
  `field_type` char(1) NOT NULL default 'T',
  `field_options` text,
  `field_default` text,
  `field_required` tinyint(1) NOT NULL default '0',
  `field_size` smallint(6) default NULL,
  `field_rows` smallint(6) default NULL,
  `field_cols` smallint(6) default NULL,
  `field_order` smallint(6) NOT NULL default '0',
  `field_browse` tinyint(1) NOT NULL default '0',
  `field_group_id` int(10) unsigned default NULL,
  `field_highlight` tinyint(1) default NULL,
  `field_search` tinyint(1) default NULL,
  PRIMARY KEY  (`field_id`),
  KEY `field_browse` (`field_browse`),
  KEY `field_group_id` (`field_group_id`),
  KEY `field_hilight` (`field_highlight`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_field_entries`
-- 

DROP TABLE IF EXISTS `ibf_registry_field_entries`;
CREATE TABLE `ibf_registry_field_entries` (
  `entry_id` int(10) unsigned NOT NULL auto_increment,
  `field_id` int(10) unsigned NOT NULL default '0',
  `item_id` int(10) unsigned NOT NULL default '0',
  `field_value` mediumtext NOT NULL,
  PRIMARY KEY  (`entry_id`),
  KEY `garage_id` (`item_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_gallery`
-- 

DROP TABLE IF EXISTS `ibf_registry_gallery`;
CREATE TABLE `ibf_registry_gallery` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `item_id` int(10) unsigned NOT NULL default '0',
  `image_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_guestbooks`
-- 

DROP TABLE IF EXISTS `ibf_registry_guestbooks`;
CREATE TABLE `ibf_registry_guestbooks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `item_id` int(10) unsigned NOT NULL default '0',
  `author_id` mediumint(8) NOT NULL default '0',
  `post_date` int(10) NOT NULL default '0',
  `ip_address` varchar(16) NOT NULL default '',
  `post` text,
  PRIMARY KEY  (`id`),
  KEY `garage_id` (`item_id`),
  KEY `author_id` (`author_id`),
  KEY `post_date` (`post_date`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_images`
-- 

DROP TABLE IF EXISTS `ibf_registry_images`;
CREATE TABLE `ibf_registry_images` (
  `attach_id` int(10) unsigned NOT NULL auto_increment,
  `attach_location` varchar(255) NOT NULL default '',
  `attach_hits` int(10) unsigned NOT NULL default '0',
  `attach_ext` varchar(10) NOT NULL default '',
  `attach_file` varchar(255) NOT NULL default '',
  `attach_thumb_location` varchar(128) NOT NULL default '',
  `attach_thumb_width` smallint(5) NOT NULL default '0',
  `attach_thumb_height` smallint(5) NOT NULL default '0',
  `attach_is_image` tinyint(1) NOT NULL default '0',
  `attach_date` int(10) NOT NULL default '0',
  `attach_filesize` int(10) NOT NULL default '0',
  PRIMARY KEY  (`attach_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_items`
-- 

DROP TABLE IF EXISTS `ibf_registry_items`;
CREATE TABLE `ibf_registry_items` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `member_id` int(10) NOT NULL default '0',
  `image_id` int(10) unsigned default NULL,
  `views` int(10) unsigned NOT NULL default '0',
  `date_created` int(10) default NULL,
  `date_updated` int(10) default NULL,
  `guestbook_pm_notify` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `date_created` (`date_created`),
  KEY `date_updated` (`date_updated`),
  KEY `member_id` (`member_id`),
  KEY `views` (`views`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_makes`
-- 

DROP TABLE IF EXISTS `ibf_registry_makes`;
CREATE TABLE `ibf_registry_makes` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `make` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `make` (`make`(64))
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_models`
-- 

DROP TABLE IF EXISTS `ibf_registry_models`;
CREATE TABLE `ibf_registry_models` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `make_id` int(10) unsigned NOT NULL default '0',
  `model` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `make_id` (`make_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_mods`
-- 

DROP TABLE IF EXISTS `ibf_registry_mods`;
CREATE TABLE `ibf_registry_mods` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `item_id` int(10) unsigned NOT NULL default '0',
  `member_id` int(10) NOT NULL default '0',
  `category_id` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `price` int(10) unsigned NOT NULL default '0',
  `install_price` int(10) unsigned NOT NULL default '0',
  `rating` tinyint(2) default NULL,
  `comments` text,
  `image_id` int(10) unsigned default NULL,
  `date_created` int(10) default NULL,
  `date_updated` int(10) default NULL,
  PRIMARY KEY  (`id`),
  KEY `member_id` (`member_id`),
  KEY `garage_id_2` (`item_id`,`category_id`),
  KEY `category_id` (`category_id`),
  KEY `garage_id` (`item_id`),
  KEY `date_created` (`date_created`),
  KEY `date_updated` (`date_updated`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_rating_defs`
-- 

DROP TABLE IF EXISTS `ibf_registry_rating_defs`;
CREATE TABLE `ibf_registry_rating_defs` (
  `rating_id` int(10) unsigned NOT NULL auto_increment,
  `rating_name` varchar(255) NOT NULL default '',
  `rating_order` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`rating_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_rating_entries`
-- 

DROP TABLE IF EXISTS `ibf_registry_rating_entries`;
CREATE TABLE `ibf_registry_rating_entries` (
  `entry_id` int(10) unsigned NOT NULL auto_increment,
  `member_id` int(10) unsigned NOT NULL default '0',
  `item_id` int(10) unsigned NOT NULL default '0',
  `rating_id` int(10) unsigned NOT NULL default '0',
  `rating_value` int(11) NOT NULL default '0',
  `rating_date` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry_id`),
  KEY `item_id` (`item_id`),
  KEY `rating_id` (`rating_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_rating_reports`
-- 

DROP TABLE IF EXISTS `ibf_registry_rating_reports`;
CREATE TABLE `ibf_registry_rating_reports` (
  `entry_id` int(10) unsigned NOT NULL auto_increment,
  `item_id` int(10) unsigned NOT NULL default '0',
  `rating_id` int(10) unsigned NOT NULL default '0',
  `rating_count` int(10) unsigned default NULL,
  `rating_sum` int(10) unsigned default NULL,
  PRIMARY KEY  (`entry_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `ibf_registry_sessions`
-- 

DROP TABLE IF EXISTS `ibf_registry_sessions`;
CREATE TABLE `ibf_registry_sessions` (
  `ses_id` varchar(32) NOT NULL default '',
  `ses_time` int(11) NOT NULL default '0',
  `ses_start` int(11) NOT NULL default '0',
  `ses_ip_address` varchar(16) NOT NULL default '',
  `ses_value` text,
  PRIMARY KEY  (`ses_id`)
) TYPE=MyISAM;
